LOB Functions¶

BIT_TO_BLOB¶

BIT_TO_BLOB(blob_type_column_or_value)¶

This function converts BIT or VARYING BIT type into BLOB type.

Parameters:	blob_type_column_or_value -- Target column or value to convert
Return type:	BLOB

BLOB_FROM_FILE¶

BLOB_FROM_FILE(file_pathname)¶

This function read the contents from the file with VARCHAR type data and returns BLOB type data.

Parameters:	file_pathname -- the path on the server which DB clients like CAS or CSQL are started
Return type:	BLOB

SELECT CAST(BLOB_FROM_FILE('local:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS BIT VARYING) result;

SELECT CAST(BLOB_FROM_FILE('file:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS BIT VARYING) result;

BLOB_LENGTH¶

BLOB_LENGTH(blob_column)¶

The length of LOB data stored in BLOB file is returned.

Parameters:	clob_column -- The column to get the length of BLOB
Return type:	INT

BLOB_TO_BIT¶

BLOB_TO_BIT(blob_type_column)¶

This function converts BLOB type to VARYING BIT type.

Parameters:	blob_type_column -- Target column to convert
Return type:	VARYING BIT

CHAR_TO_BLOB¶

CHAR_TO_BLOB(char_type_column_or_value)¶

This function converts CHAR or VARCHAR type into BLOB type.

Parameters:	char_type_column_or_value -- Target column or value to convert
Return type:	BLOB

CHAR_TO_CLOB¶

CHAR_TO_CLOB(char_type_column_or_value)¶

This function converts CHAR or VARCHAR type into CLOB type.

Parameters:	char_type_column_or_value -- Target column or value to convert
Return type:	CLOB

CLOB_FROM_FILE¶

CLOB_FROM_FILE(file_pathname)¶

This function read the contents from the file with VARCHAR type data and returns CLOB type data.

Parameters:	file_pathname -- the path on the server which DB clients like CAS or CSQL are started
Return type:	CLOB

If you specify the file_pathname as the relative path, the parent path will be the current working directory.

For the statement including this function, the query plan is not cached.

SELECT CAST(CLOB_FROM_FILE('local:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS VARCHAR) result;

SELECT CAST(CLOB_FROM_FILE('file:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS VARCHAR) result;

CLOB_LENGTH¶

CLOB_LENGTH(clob_column)¶

The length of LOB data stored in CLOB file is returned.

Parameters:	clob_column -- The column to get the length of CLOB
Return type:	INT

CLOB_TO_CHAR¶

CLOB_TO_CHAR( clob_type_column [USING charset] )¶

This function converts CLOB type into VARCHAR type.

Parameters:	clob_type_column -- Target column to convert charset -- The character set of string to convert. It can be utf8, euckr or iso88591.
Return type:	STRING